load data
 infile 'D:\Userdata\db\attemptedvis.csv'
 replace
 into table attempted
 fields terminated by "," optionally enclosed by '"'
TRAILING NULLCOLS  
  (pemail char "TRIM (:pemail)", adate date "MMDDYYYY", cemail char "TRIM (:cemail)", scode char "TRIM (:scode)", cmedium char "TRIM (:cmedium)")
